<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>

<%@include file="top.jsp"%>
<%@include file="left.jsp"%>
<%
String strNewsId = request.getParameter("newsid");
int newsid = 0;
if(null == strNewsId || "".equals(strNewsId)){

	}else{
		newsid = Integer.parseInt(strNewsId);
		Connection dbcNews = db.getConnection();
		String sqlNews = "SELECT n.title, n.author, n.subtitle,n.content1,n.source, n.createdate, a.areaname, c.catalogname FROM news AS n, area AS a, catelog AS c WHERE n.areaid=a.areaid AND n.catalogid=c.catalogid AND newsid=?";
		PreparedStatement stmtNews = dbcNews.prepareStatement(sqlNews);
		stmtNews.setInt(1, newsid);
		ResultSet rsNews = stmtNews.executeQuery();
		if(rsNews.next()){
 %>
       <div id="content" class="align-right"><br/>
				<div id="shijit">
				<center>
                  <h2><%=rsNews.getString("title") %></h2><br/>
                  <h4><%=rsNews.getString("subtitle") %>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=rsNews.getString("source") %></h4>
                </center>
                </div>
              <div id="shiji" class="neirong">
                <p>
                 &nbsp;&nbsp;&nbsp;&nbsp;<%=rsNews.getString("content1") %>
               <div id="renyua">               
                <%=rsNews.getString("author") %><br/><br/><br/><br/><br/><br/>
                <%=rsNews.getString("createdate") %>
               </div>
                <div id="leibie">
                <%= rsNews.getString("areaname")%><br/><br/><br/><br/><br/><br/><br/>
                <%= rsNews.getString("catalogname")%>
                </div>
                <br/><br/><a href="city_info.jsp">返回</a><br/>
                </div>
			</div>
<%}
rsNews.close();
dbcNews.close();
}


 %>
<!-- 特殊 选中样式 -->
<script type="text/javascript">
	
	$(document).ready(function(){
		
		/*选中，如下*/
		$('#li-info').addClass('on');
		
	});
</script>

<%@include file="bottom.jsp"%>
